var user = {
    queryAll: 'select * from y_userInfo order by id desc limit ?,? ',
    updatePersonInfo:'update y_userinfo set name=?, tel=?, email=?,birthday=?,address=?,sex=? where id=?',
    queryInvite:'select id,name from y_userInfo',
    del:"delete from y_userInfo where id = ? ",
    queryById:'select name,tel,email,birthday,address,sex from y_userInfo where id = ?',
    queryByName:'select * from y_userInfo where name like ?',
    add:'insert into y_userInfo(name,tel,email,birthday,address,sex) values(?,?,?,?,?,?) ',
    queryPersonInfo:'select name,tel,email,birthday,address,sex,id from y_userInfo where id = ?',
    queryTel:'select * from y_userInfo where tel=? AND id!=?',
    queryTelExist:'select * from y_userInfo where tel=?',
};

module.exports = user;
/**
 * Created by Administrator on 2015/8/6.
 */
